Integrating with a separate SQL Server computer
Meridian can be integrated with a SQL Server installation on the computer where Meridian is also installed or on a separate computer. SQL Server installations on the Meridian computer are detected by the Meridian setup program as described in Installing the server components.
Note
- Document content (stream) files are typically stored on the Meridian application server regardless of where the database is located.
- If the network connection between the Meridian application server and the SQL Server computer is interrupted for any reason (for example, SQL Server is restarted), errors can occur. Any pending transactions will not be committed to the database. To resume proper operation, restart the EDM Server service.
To integrate Meridian with SQL Server installed on a separate computer:
- Set up the Meridian application server as described in Installing the server components if you have not done so already.
- For new vaults, create the vault that you want to use with SQL Server as described in Creating a new vault. For existing vaults, proceed as described in Restoring a SQL Server vault to another server or Migrating a Hypertrieve vault to SQL Server, accordingly.
- Create a subfolder named Backup on the SQL Server computer in the path typed for the Path for Database Files option in step 2. If this subfolder is not created, the backup will fail for this vault.